package com.edu.mapper;

import com.edu.bean.Departement;
import com.edu.bean.DepartementExample;
import java.util.List;

import com.edu.bean.Employee;
import org.apache.ibatis.annotations.Param;

public interface DepartementMapper {

    // 根据部门id查询部门及员工信息
    Departement selectDeptAndEmployeesById(Integer dId);

    List<Employee> selectAllByDeoAndEmp(@Param("name") String dName);

    // 查询所有部门及其员工信息
    List<Departement> selectAllDepartmentsWithEmployees();

    long countByExample(DepartementExample example);

    int deleteByExample(DepartementExample example);

    int deleteByPrimaryKey(Integer dId);

    int insert(Departement row);

    int insertSelective(Departement row);

    List<Departement> selectByExample(DepartementExample example);

    Departement selectByPrimaryKey(Integer dId);

    int updateByExampleSelective(@Param("row") Departement row, @Param("example") DepartementExample example);

    int updateByExample(@Param("row") Departement row, @Param("example") DepartementExample example);

    int updateByPrimaryKeySelective(Departement row);

    int updateByPrimaryKey(Departement row);
}